﻿/********************************************************************************************************************
* Author:	Aris Michail																							*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_getPendingCategories" that returns the *
*			categories that are not yet approved.																	*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_getPendingCategories]
AS
	SELECT *
	FROM Categories
	WHERE Categories.IsApproved = '0' and Categories.IsDeleted = '0'
RETURN 0